Elements and Performance Criteria
- Write a simple SQL statement to retrieve and sort data
- Write an SQL statement that selectively retrieves data
- 2.1 Restrict the number of rows retrieved, by placing criteria in the 'where' clause
- Restrict the number of rows retrieved, by placing specific criteria in the select statement
- 2.3 Use comparison operators in the 'where' clause to compare numeric, character, string, date and time data
- Use Boolean operators with the correct precedence
- 2.5 Use criteria in the 'where' clause, to check for a range of values, to select values from a list, and to check for values that match a pattern
- Use SQL syntax to suppress duplicate values from query results
- Take action to exclude null values from a query result
- Write SQL statements that use functions
- Write SQL statements that use aggregation and filtering
- Write SQL statements that retrieve data from multiple tables
- Employ the inner join syntax, to retrieve data from two or more tables
- 5.2 Use 'left outer', 'right outer' and 'full outer' syntax, to join tables in the select statement
- 5.3 Use correct syntax in the 'where' clause, to retrieve data from multiple tables
- Write a union query that retrieves data from more than one table
- Write and execute SQL sub-queries
- Create and manipulate tables
- Create and use views
- Create and use stored procedures
- Create and execute stored procedures that use SQL to retrieve, insert, or modify data, according to information requirements
- Create and execute stored procedures, that use one or more parameters
- Drop a stored procedure from the database
- Create and test database triggers that automate data management, or perform specific required data-related functions